<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Incremental Fetch on Grid/Graphs</title>
<link rel="stylesheet" href="RoboHTML_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='RoboHTML.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { font-weight:bold; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nImproving document execution performance\nIncremental Fetch on Grid/Graphs");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Incremental Fetch on Grid/Graphs</h1>
<p>Incremental fetch divides large Grid/Graphs into pages, thereby loading 
 the data in batches (or blocks) rather than all at the same time. This 
 improves the usability and performance of a large Grid/Graph, by reducing 
 the load and overall memory usage on the web server. Only a Grid/Graph 
 displayed as a grid can be split into rows and therefore incrementally 
 fetched. This includes the grid portion of a Grid/Graph displayed as both 
 a grid and a graph simultaneously.</p>
<p><span style="font-weight: bold;"><B>Note: </B></span>this property applies 
 only to the rows, not to the columns, of the Grid/Graph. </p>
<p>You can define the incremental fetch options for Grid/Graphs in either 
 MicroStrategy Web or in Desktop, but incremental fetch is applied only 
 when the document is executed in Editable Mode, Interactive Mode, or View 
 Mode in MicroStrategy Web. Desktop does not apply incremental fetch to 
 Grid/Graphs.</p>
<p>The blocks of data are defined by the number of rows to return at a 
 time. For example, a Grid/Graph on a document contains 1000 rows. Incremental 
 fetch is applied, with the number of rows per page set to 50. In MicroStrategy 
 Web, only 50 rows are displayed on a single page of the Grid/Graph. Users 
 can navigate to another page to display more information.</p>
<p>You can also apply incremental fetch to the entire document. For more 
 information, see 
<a href="Incremental_Fetch.htm">Incremental Fetch on 
 documents</a>.</p>
<h2>Incremental fetch in repeating document sections</h2>
<p>Whether the group and detail sections repeat in a document affects how 
 incremental fetch is applied to Grid/Graphs in that section, as described 
 below:</p>
<ul>
<li class=p-First-Bullet-Do-Not-Type-Text><p class=First-Bullet-Do-Not-Type-Text>&nbsp;</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>If all 
 the elements of a grouping field are displayed simultaneously, the Group 
 Header, Group Footer, Detail Header, and Detail Footer sections repeat, 
 once for each element in the group. Only the first page of data from the 
 Grid/Graph is displayed. Users cannot navigate to another page.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>If only 
 one element is displayed at a time, these sections appear only once. A 
 Grid/Graph placed in one of these document sections does not repeat, and 
 users can navigate to other pages. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>If the 
 document is not grouped, the Detail Header and Detail Footer sections 
 appear only one time. A Grid/Graph placed in one of these document sections 
 does not repeat, and users can navigate to other pages. If the document 
 is not grouped, the Group Header and Group Footer are not displayed.</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>Although 
 the Detail section repeats, a Grid/Graph cannot be placed in it, so the 
 Grid/Graph incremental fetch setting does not apply. </p></li>
</ul>
<p>For background information on document sections, see 
<a href="Sections_in_documents.htm">About 
 sections in documents</a>. For instructions to group the document, see 
 
<a href="Grouping_data.htm">Grouping records in a document</a>. For instructions 
 on displaying individual grouping elements or all the elements, see 
<a 
 href="Using_pageby_on_a_document.htm">About using page-by on a document</a> 
 (page-by interactively displays groups on separate pages).</p>
<h2>To apply incremental fetch to a Grid/Graph</h2>
<ol>
<li class=p-Steps><p class=Steps>Open a document in the Document Editor.</p></li>
	
<li class=p-Steps><p class=Steps>Right-click the Grid/Graph to apply 
 incremental fetch to, and select <span style="font-weight: bold;"><B>Properties</B></span>. 
 The Properties dialog box opens.</p></li>
	
<li class=p-Steps><p class=Steps>Click the <span style="font-weight: bold;"><B>Advanced 
 </B></span>tab.</p></li>
	
<li class=p-Steps><p class=Steps>Select the &nbsp;<span 
 style="font-weight: bold;"><B>Enable incremental fetch on grid</B></span> check 
 box.</p></li>
	
<li class=p-Steps><p class=Steps>Enter the <span style="font-weight: bold;"><B>Maximum 
 number of rows per page.</B></span></p></li>
	
<li style=" font-weight: normal; " class=p-Steps><p class=Steps style="font-weight: normal;">Click 
 <span style="font-weight: bold;"><B>OK</B></span> to return to the document.</p></li>
</ol>
<p>To see the results of the incremental fetch, open the document in MicroStrategy 
 Web in Editable Mode, Interactive Mode, or View Mode. </p>
<p class="whs1">Related Topics</p>
<ul>
<li style="font-weight: bold;" class=p-First-Bullet-Do-Not-Type-Text><p 
 class=First-Bullet-Do-Not-Type-Text>&nbsp;</p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>
<a href="Using_GG_in_documents.htm">About 
 using Grid/Graphs in documents</a></p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>
<a href="Incremental_Fetch.htm">Incremental 
 Fetch on documents</a></p></li>
</ul>

<li class=p-First-Steps-Do-Not-Type-Text><p class=First-Steps-Do-Not-Type-Text>&nbsp;</p></li>

<li class=p-Steps><p class=Steps>&nbsp;</p></li>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
